Filter function

To apply function:

§          Filter                                         MDX Filter

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … Filter from submenu

 

 

In our case let us try to see:

 

all hCountry members whose Store Cost is greater then 100,000,000.00

 

Dialog will appear:

 

 

§          set appropriate value

o         in our case 100,000,000.00 instead of 10.00

§          define  measure if selected one is not suitable for you

o         we will replace Unit sale as we said with Store Cost

Ø       to select another measure, just click button Select

Ø       select from dialog  measure Store Cost

Ø       select Ok

§          define members to create tuple if appropriate (not in our case)

o         for example to add Food select button Add

Ø       find  member Food

Ø       select Ok

 

·            select OK

When we set all parameters as we agreed, dialog will look like this:

 

 

After confirmation result is: